David Orr will stand down from his role as chief executive of the National Housing Federation (NHF) in September