Scusset Beach State Reserve is located on the Cape Cod Canal and Scusset beach. Water /electric with dump station. Horseneck State Beach in Westport, Ma, but no hook ups is right on the beach. There are a few in RI, but no hook ups.
If you are will ing to drive a couple extra hours, look into Libby's Campground in York Harbor, Maine.