From Great Wolf Lodge to Fairmont Scottsdale Princess to Arizona Grand Resort, these hotel water parks in Phoenix and Scottsdale are fun for all ages.