A much-loved haberdashery shop popular with knitters and sewers which has been a familiar constant on a Yorkshire high street has closed after 40 years.