Revamped pub's intoxicating views