The pub in the heart of the Deeside community has been shut for years.