Having experince in supplying for the Scandinavian market water driven double acting actuators, supplied from freshwater mains, actuators both linear and for 90 degrees - for valves: this is possibel and relatively trouble free, but depending on water quality.
Following points:
Water to be normal drinking/freshwater having passed a normal drinking water treatment plant.
Water must in addition be supplied over a fine (household) water filter (microsize), selfcleaning - handoperated or automated, directly in front or nearest possibel the cylinder.
Cylinder must be operated regularily to change the water. Cooler climate and water at least once a month, for warmer perhaps at least once a week or once each 48 hours?
Cylinder ought perhaps to be inspected after a trial periode to check for chalk or mineral deposits. (You actually will not know possibly negative chemical raections before you actually try, this could occur in some few cases, one per cent or less ?)
The customer must accept a possibel shortened lifetime.
We have had cylinders working trouble free for many years running, a few others from certain areas/locations that unexplained gives trouble -(could be false operating, poor filtering).
Soft sealings for cylinder to be supplied with cylinder, extra cylinder complete if critical.
Cylinder shaft to be equipped with scraper/sealing if available.
Hand operated or special solenoid valve for water to operate the cylinder (special types suitable)
Water is a non-compressibel medium and at low/normal pressure will need time to fill a cylinder through relatively small borings. Beware of necessary operating time! (Can be rougly calculated giving boring size and guessing at a sensible water speed)
Allow cylinder area to compensate for possibly lower water pressure than stated.
Cylinder material: quality grade aluminium could be used, but stainless steel recomended.
And last: why water operation to complicate things, air or electrical would be better?! What's wrong about a standard lifting table electrohydraulic or electric from floor up, or electric hoisting device from ceiling down. Even a oil-hydraulic cylinder with a smaller separate aggregate would probably have lower lifetime cost!
Main use in my area : To operate gate valves, mainly DN300 up to DN500 where water pipes are present, and electric not present, too complicated or costly. Cylinder material: aluminium, allowed for water by the cylinder fabricator.