A popular pub in Leeds city centre has reopened following seven-figure investment.