We tried to go a few times however; the "timeshare" hotels fills up quick. They had a 6 month wait list the last 2 times we called.
You can go there and pay to get into the water park. We did not do that because I have heard it can be quite full.
Not much farther away is the Great Wolf lodge....we stayed there instead.
I have heard that there waterpark is better than the GWL but the hotel part is in serious need of a rehab.