I am unclear as to why you would need a tank, where it would be put to
avoid being unsightly*, and where the water would go when the tank
became full?

I doubt building regs would accept a tank. Also much new legislation
about soakaways and not overloading public drainage with sudden surges.