Discover the charming and historic little town situated in the heart of the Scottish Borders that is best explored in autumn