The Sunday Times Best Places to Live in the UK for 2026 has been released, with a rural city taking the top spot