The chief executive of the NHS trust that runs Scarborough Hospital has announced his plan to retire in the autumn with a recruitment process set to take place over the summer.