Derelict Southampton site to be demolished with new flats to