Louise Long reveals how to spend the ultimate break in the UK’s city of dreaming spires