A popular County Durham cafe has hit the market and is up for sale for £600,000.