CIA Director resigns over extramarital affair