Villagers who have been without a pub for eight years have finally been able to welcome one with open arms