More than 1,300 homes, including a ‘landmark’ tower block, are set to be built in a £290 million transformation of two Sheffield neighbourhoods.