Dont all die of shock but I have never been to any of the water parks

I keep hearing that some are open some are closed part of the year so can someone help explain. Is there only 1 water theme park open at any one time? Do we need special tickets and if so which? Are they even worth it?