Poverty is “moving in the wrong direction in Sheffield”, says the city’s director of public health.