Jonathan Powell will take over from Sir Tim Barrow in the role based in 10 Downing Street, the Cabinet Office said.