Yes, the CEO of a water utility would be a hypocrite for opposing the development of a water tower next to eir ranch. Presumably the CEO of a water utility would understand that water towers are a useful part of municipal water distribution (though they have been largely replaced by pumps these days) and would have been involved in the selection of a location as part of his role in the utility.
On the other hand, a water utility CEO who didn't want that water tower near eir place for aesthetic reasons might ensure that there are multiple sites proposed, then start campaigning on environmental grounds to prevent the necessary roads being bulldozed to the site(s) where E doesn't want the tower: the NIMBY situation can be expressed in terms that everyone else with agree with ("there's a rare butterfly which only breeds in this area. Disrupting the environment would be awful!").
And that's what's happening here: "I don't want a fracking project messing up my backyard, so I'll protest against the stuff required to make that project viable."
The CEO is fully aware of the infrastructure requirements of the project, and if E wasn't concerned about the environmental impacts would otherwise have been proud to have a project nearby because it's a visible sign that the USA is taking responsibility for its own fuel supplies.