The Backbay in Newport would be fun.
All kinds of family oriented amenities, from swimming lagoon to sailboat, kayak, windsurf rentals rentals.
Night life and good food are a couple minutes drive.
Make sure to rent a Duffy electric boat for a harbor tour and to get some dinner in Newport Harbor.
Best of luck. Dave