From a sleek city stopover in Scotland to a coaching inn upgrade in Cumbria, these hotels won’t break the bank ...