Low Cost Motorized Valve
You can get sprinkler valves, that use solenoids, for under $20 that fit on plastic PVC pipe and are designed for water, such as these at SprinklerWarehouse.  They typically use pipe sizes of about 1 inch.