Well thought out places to stay, from sleek adults-only retreats to all-singing, all-dancing hotels just right for families