Rated by the Travel Channel as "America's No. 1 Waterpark," this fun family resort spreads over 65 acres with thrills, spills and water rides.