A picturesque walking route in the UK with award-winning gardens and views of a breathtaking castle has been praised as being just like a 'fairytale'