Road trip

thinking of visiting in August/September with 3 young kids. last time I visited was 2002. where are some good places to stay (ideally near the water), things to do, all of that. we'll be driving from Canada. thanks!!!