Permission has been granted to transform the 600 acres former steelworks site into a £1bn mixed-use development comprising housing, office and industrial space, public open space and a range of community facilities.