Jonathan Powell worked closely with his US counterpart Mike Waltz to get the agreement over the line, government sources said