Louise Herron says leading the iconic Sydney Opera House for more than a decade has been the "most incredible honour and privilege".