Councils have been accused of a “moral failure” to provide decent housing to homeless people and of overseeing a “fiscal disaster” as costs top quarter of a billion.