This Northumberland village with medieval abbey ruins has been named one of the UK's prettiest by top travel bloggers.