The water and land required for vegetables farming isn't a problem. We don't need to move lettuce production into buildings, mines or submarine farms.
Most of the water & land is used for cereal farming.
Whatever you can grow in a mine or a skyscraper can be grown on a "small" farm near a city. Whatever water saving, pesticide minimizing, or other benefits you get have little to do with location.
There are plenty of led/hydroponic farms in normal farming places.