A landmark building in Edinburgh’s financial district is to undergo a £200 million transformation to become Lloyds Banking Group’s main base in Scotland.