Unless there is construction going on, ALL waterparks have indoor access. 2 are closer to each other and the third is at the other end of the resort, but is next to the arcade and dry play area.
If coming with small kids I would bring a stroller to help get from room to the waterparks. Once our kids got 4 we no longer took a stroller but with younger kids I would highly recommend it.
I always request the top floor. It can get noisy with people running around to/from waterparks.
If crowds bother you, avoid Friday/Saturday. When we go we go on a Thursday we always have had great luck with low crowd levels. If not a worry, then disregard.
As for rooms, we usually stay at glacier canyon or choose a room with a sofabed since we are a family of 5. Never paid much attention to the views since we are there for the waterparks.
Have fun! Any other questions please just ask.