A report has found vulnerable youngsters are waiting too long for support due to "systemic failings" in Leeds's special needs service.