Elon Musk has said he will resign as Twitter's chief executive officer when he finds someone "foolish enough to take the job".