Question: where is the water park movie?
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.