Modern CEOs faces huge pressure and competition. They’re increasingly turning to a new corporate warrior who is part adviser, part PA, part consigliere.