More must be done to stop children being housed in bed and breakfasts and temporary accommodation, says a report.