A popular pub has reopened after a major makeover.