Lawn Irrigation Pumps

which is cheaper to run one of which is connected to mains water or establishment of a well. So I guess this is just the cost of tap water or the cost of electrcity to run the well pump.

It depends where you are, but here in Aus it is water that is cheaper. A much better option is to obtain a drought-susceptible strain of grass.