The chief executive of Cork Opera House, who led the venue back from the brink of financial collapse, is to leave her position when her five-year contract expires later this year.