Former Downing Street chief of staff Sue Gray has decided not to take up the role of envoy to the nations and regions, Number 10 has said.