A long running and much-loved North Yorkshire business has closed.