I stayed at the Holiday Inn and Suites when it was Nickelodeon. The water park was nice, but you are going to run into people that can cause issues. There were A LOT of drunks at this resort. Very ill behaved drunks and this was at all hours of the day. There was a drunk dad that knocked kids over and out of the way to go down slides. It was all over. There was one night at the arcade area where police had to come arrest a guy because he was so drunk, screaming at a Muslim family that they were terrorists, and almost attacking them.
If money is not the issue, then I recommend Gaylord Palms. I have not stayed there, but know people that have and absolutely love it.