Want to take the kids on holiday and still get a break yourself? Here are the perfect places to stay