Brendan:
Russell has the technical background; I've just seen a lot of different stuff. Every site is different.
In Bandon the sand is over the top of sandstone layers ... you never know how deep until you dig a hole. The construction of Bandon Dunes discovered that some pockets were very close to sandstone, so you could not expect the drainage to percolate down. They went back with major drainage, with pipe outfalls toward the ocean.
Knowing that, when we did Pacific Dunes, we put all the main drainage lines in, as part of construction. The one difference with our system was that because we hate those green plastic drain caps, and because the ground never freezes in Bandon, our drains consist of a loop of perforated pipe buried a foot deep underground. It sucks the water out of the low spots just fine, and you never see evidence of the system.
We got that idea from Kingsbarns ... which got it from St. Andrews. They installed a similar system at St. Andrews 15-20 years ago. When I caddied there, a wet spell would leave puddles of water in places on the links, because the whole place is not too far above water table I suppose. Anyway, they ran a bunch of main drains years ago to fix that problem, with some of the $$$ they collect from green fees.
Ballyneal does not have any drains, just sumps as at Erin Hills ... the sand is so deep and the climate so dry that we don't expect any problems to surface. Sand Hills took the same tack. At Barnbougle we didn't even bother with sumps in most places, the sand pulls the water down plenty well, but there are a couple of places on each nine which are very low and drainage was installed to move the water out.
There is no drainage underneath the greens at any of the courses I've spoken of, and only underneath the bunkers where they are in low spots overall at Pacific Dunes and Bandon Dunes and Kingsbarns and St. Andrews.