I would concur with the location for kids. The two hotels, Renaissance and Residence Inn are actually connected by the Waterpark. So, if you're looking for a budget, opt for the Residence Inn.
The waterpark is small by most Minnesota/Wisconsin Dell standards but, it should be most kids (up to early teens) entertained for a day. However, there are a number of other attractions within easy walking/driving distance for the older crowd.