A popular East Lothian cafe which is said to serve the 'best pizzas in town' has announced they are to close.