The chief executive of Leeds City Council has been asked by government to play a key role in its coronavirus contact tracing programme.