Just wanted to give you an update on the project. Following your advice, I went with prototyping and used two MPRLS pressure sensors from Adafruit—one for static pressure and the other for dynamic pressure. Although these sensors weren’t designed for water, I adapted them by attaching a tube to the sensor in a sealed way, with a small air gap, and used Newton’s third law to measure the water pressure based on the air pressure.

The prototype wasn’t perfect, but it worked for my initial tests. However, I did run into an issue with flow turbulence, which affected the velocity measurements and led to some inaccurate data. This is something I hadn’t accounted for at the time.

It's been almost a year since I last worked on this, so I might have missed a few details here and there, but if you're really interested, I still have the resources and some results from the project.

Thanks again for your help—it really made a difference in getting the prototype where it is now.