I have thought about doing this myself as the clay lines for my gutters are breaking down. Hard part is I can only dig in the yard in spring or fall (clay soil) and when its dry, its harder than a rock.
https://www.instructables.com/id/How-to-Install-a-DownspoutSump-Drywell-to-Reduce-F/