August is definitely the worst of the summer months in terms of heat. June and July should be a little better, especially if they're doing a water based activity (I'm not sure what ages your kids are, but I know the older ones stick to one activity the whole week).