'Breathtaking walk' named best in the UK for staycations