Whether you're looking at a mood-lifting minibreak, a full-on holiday, or just a little overnight pick-me-up these hotels are all very much worthy of your attention