There are many raspberry pi projects on reddit for the "microgrowery" community... I recommend having a search. I plan to set up an indoor tomato and herb garden using these methods.
For solenoids, I advise some methods like [1] so that you can connect a cheap and daisy-chainable relay board like [2] via SPI. Then you can control anything.
If you don't want to get down into the 5v to 3.3v mumbo jumbo, it may be easiest to connect an arduino or clone via USB to the raspberry pi. There are bazillions of documented ways to drive relays with an arduino.
[1]: https://www.tansi.org/rp/interfacing5v.html
[2]: https://www.ebay.com/itm/SPI-breakout-board-with-6-relays-fo...
Think about using a bell siphon [1]. Its typically used in aquaponics with a constant stream of water being pumped, but the pump can certainly be switched with a relay/pi/sensor setup to allow for intermittent dry spells (depending on what your growing). Water can be pumped from a nearby reservoir or tank.
[1] https://worldwaterreserve.com/aquaponics/bell-siphon-for-aqu...
There is a related subreddit: https://www.reddit.com/user/takecareofmyplant/
https://www.amazon.com/dp/B07L491F8K/ref=cm_sw_r_tw_dp_U_x_d...
https://github.com/vrachieru/xiaomi-flower-care-api
My plan is to use that and build a Raspberry Pi to monitor my plants. And later on maybe control the watering system.
Anyways, it's a nice cheap plant monitoring option. It was really helpful when I was trying to figure out why my plants were turning yellow. People were mostly telling me that I was either over watering or under watering, etc. Then the probes all told me that my soil has no fertility left so I just added some organic 5-5-5 fertilizers and my plants are doing great again. The nerd in me love checking the data every day but would ideal build a Raspi server to sync and display some graphs some day (using a Prometheus endpoint perhaps?)
If anyone has good advice on how to control a set of water valves using Raspberry Pi, please let me know! I know about GPIO but I would like to have a bus of some sort so I can add more valves in the future if needed. Maybe a USB solenoid?