From giant indoor and outdoor water parks to themed attractions, see why this is one of America’s top family vacation spots.