Winter Island might work for a central North Shore location where camping, boat launch, etc. are available. NEKF holds its annual Shootout there.
http://www.salemweb.com/winterisland/
Also Salem sights and history could pacify wifey and family members........ Salem is a good central meeting spot from which you could hit Plum Island to the north or Nahant to the south, and everything in between.