Water ride at amusement park