With plenty of diversions for both grown-ups and kids, these fabulous hotels promise family fun for the whole brood