The tragic death of a Sheffield woman highlights the ‘shocking life expectancy of people sleeping rough’, a councillor has said.