While neither of them have hotels attached to them, there are plenty of hotels nearby to Water Country USA in Williamsburg, VA and at the Beach near Cincinnati, OH. Busch Gardens in VA and King's Island in OH are both right next to the water parks and there are often multi day multi park ticket deals to be had. I have been to both and enjoyed them both.