Get a tent, hit a campground, then hit up all the nearby stuff that you like to do with the kids.

Nicer but more expensive get a house rental and again, do local things the kids enjoy.

Honestly, a tour of local public playgrounds is wild fun for kids on vacation - at least in my experience.