From coastal retreats, to city centre streets, these are the best hotels in the UK for families young and old