A Leigh Park pub has reopened following a six-week £300,000 transformation.