While recording his new album with Richard Hawley in Sheffield, the legend who is Mr Duane Eddy fell in love with the city and his surroundings. Here he tells Luke Turner about his new infatuation, chilli-filled Yorkshire pudding, and why Hawley should be mayor