One of Cork city centre's best known pubs will reopen on Friday after a €500,000 makeover following a link-up with drinks ...