Question: where is the water park grown ups?
Answer: It turns out there really is a park named Water Wizz (what were its owners thinking?), located in East Wareham, Massachusetts, which served as the location for the film. Other scenes were shot in and around Massachusetts.