Water harvesting under a sidewalk

Hello from the desert southwest!

Inspired by Brad Lancaster and his work in Tuscon, my neighbors and I are trying to figure out how to harvest the copious stormwater that flows past our houses in the rainy season. Here's our essential problem: Our houses and front yards are higher than the road, by a fairly significant margin. Additionally, we live on a road that has a sidewalk, but no "hell strip" between the curb and the sidewalk that we could dig out and curb cut. It's just road/curb/sidewalk/yard, with the yard about 8-12 inches above the lowest point of the road. In all the examples I've seen of folks using curb cores or curb cuts, the curb is cut directly into a basin. Is there a good way to get water from the road, through the curb, under the sidewalk, into a basin in the yard? Anyone have experience with this?

One solution that I considered was digging a big basin in the yard, core the curb, and run a pipe through the curb, under the sidewalk, and into the basin. That presents some problems though, mainly because that involves some engineering that I don't know how to do, and I was hoping we could find a solution that we could repeat throughout the neighborhood, which is fairly poor, so a solution that involves a bunch of contracted work wouldn't be successful (as opposed to the version of curb cutting I've seen from Mr. Lancaster, which involves just the one curb cut).

Anyone have examples of places where they've dealt with this kind of setup? Any suggestions?

Thanks!

Here is an over the top system.
https://roadsonline.com.au/catching-the-rain-the-aco-way/#
I can say there will be a net work of undergrounds pipes etc to complete the system.
More details of your property are needed to give a clear response.
- what is the area available to hold water?
- what is the soil type in your area?
- Would you hold it in a pond or a tank?
- what will the water be used for?
- what volume of water do you want to catch?