Derek Tierney, currently assistant secretary general at the Department of Health, will replace Mr Watt