Plans for a Tesco superstore in the West Yorkshire town of Holmfirth, home of the BBC comedy series Last of the Summer Wine, have been axed after a campaign by residents and local independent retailers.