For a more DIY solution you can install Node-RED onto a Raspberry Pi for a GUI flow editor: https://hackaday.com/2020/01/15/automate-your-life-with-node...
Alternatively, if you'd like to do everything on the Raspberry Pi, use its GPIOs to control a relay module with optocoupler isolation (~$4) which can turn the pump on or off: https://www.aliexpress.com/item/2251832713449142.html
If you're more hardcore, you could flash a smartplug like Sonoff S31 with Tasmota and add rules that trigger based on various events (eg: timer). https://tasmota.github.io/docs/Rules/#rule-variables https://tinkerman.cat/post/sonoff-s31-now-serious
Eventually perhaps building in some moisture sensors and some pi/arduino logic to then control the pump.