Excellent mock-up of an infiltration well project! This practical method is indeed a suitable way to recycle rainwater to be filtered back to the water table and other useful cisterns or reservoirs below the earth's surface. You suggested a depth of at least 1 meter for this contraption, and in terms of the hole's opening size, what would you recommend to be its ideal dimensions?
Welcome @jhonnygo to the Architecture+Design Community!
A minimum of one meter is recommended, this most of all is at the urban planning level so that rainwater from the roof of the house does not go to the sewer system of the city and collapse!
Depending on the amount of water to infiltrate it will be the periphery, for example for a small house a 1 m3 ditch will be used.
I see, thanks for the update!