"They have asked the council time and time again to be rehoused, but they have been ignored" says a damning report from health professionals