Sheffield’s biggest office block is set to be converted into flats, the city council has confirmed.