Motherwell academy director Gordon Young is leaving the Scottish club to take up a new position at Sheffield United.