Ripon has a market that goes back 1,000 years and is within easy reach of a dreamy National Trust property