The beloved pub in the village near Aberystwyth has announced it will close for good in December