More workers are demanding their leaders take stands on hot-button issues, and some CEOs don't shy away from the controversy. But they also must navigate the risks and benefits for their workforce.