The pub has reopened after a six-figure refurbishment