The head of Tourism NI is stepping down from his role after a decade at the helm.