Cancer researcher to succeed businessman Andrew Mackenzie at time of major change for research funder.