As more properties see water fun as a strategic fit with the family friendly trend, splash pads and waterparks are popping up at clubs and resorts all over the country.