Edinburgh will know it's making a real impact on the Capital's housing emergency when homelessness falls below 1,000, the city's housing director has told MSPs.