This is a very tough decision as its hard for founders to let go and have someone else come in and take control. Sometimes VCs have to force the decision based on their own thoughts but I think the key is a founders ability to inspire, motivate and manage people. The job of a CEO is very different than that of an early stage founder who is heads down building software. If there are 2 founders, the person who is more comfortable with the management and leadership part should take over as CEO. Google got Schmidt to take over as CEO before Larry Page came back. Sergey knew that he did not want to deal with all the overhead that a CEO has to handle. Zuck on the other hand was comfortable taking over as CEO brought in Sandberg as COO to help with management.
I think the key is to understand the strengths and weaknesses of each person on the founding team.