Sheffield charity said more affordable housing is needed for Burnham to end rough sleeping