CEOs can foster a more effective leadership team by understanding when to tap senior executives’ competitive instincts and when to encourage collaboration.