Locals have been delighted at the reopening of a traditional pub which has been ‘brought back to life’ following a lengthy closure.