An NHS chief has praised her colleagues for work overcoming the challenges of recent years as she is named in the New Year Honours List.