Delight for boozers as pub set to reopen