Get soaked in fun at these globally acclaimed water wonderlands