From brilliant kids’ clubs to water sports galore, these well-thought-out stays are sure to keep the whole gang happy