It was the main filming location for one of the most-watched programmes ever and now the town is seeing an upswing in tourists