Historic towns such as Stamford are part of an emerging tourist destination that offers walks, rolling countryside and cosy pubs