Treasury minister and key figure behind the government's Northern Powerhouse Jim O'Neill has resigned today.