Having no political agenda, no "turf", and (hopefully!) no axe to grind, the right consultant can be a very effective change agent. Still, changes to the status quo are upsetting, causing employees fear and uncertainty about the future. Some conflict and fallout is inevitable, and you should be prepared for this.
A good consultant can help you minimize these effects and create a positive environment for change.