Mental health problems are said to be 'rampant' on the streets, with rough sleepers affected needing '24 hour care' if they are to be housed