CEOs are expected to be visionaries who set a bold direction for their organizations and inspire people to greatness. But leaders at other levels of the organization must also master the art of stirring up enthusiasm within their groups if they are to reach their common goals.