Cooling warm cold supply line

[Engineer]

This isn't a normal post and its almost just a thought exercise but opening it up to the forum to get some ideas. In the south, in the summer, the cold supply line can be pretty warm and while its mildly annoying I thought about how you might be able to cool it down. In my case I was looking to solve for one or two faucets, not house wide due to concerns of potential condensation in walls.
I thought about glycol chillers that are used for draft lines but this only really helps with keeping the transportation of already chilled liquid over distance. Where I have naively landed is with the idea of a stainless steel reservoir in a kegerator (or unit like that). Basically have the faucet cold supply run through a kegerator, hard lined into some vessel inside the unit and then on to the faucet. I wouldn't need the pressurization options generally found in various water storage units. This would just be a way to have 5 gallons or so chilling and when the tap is open it would push through. I have a decent height to my crawlspace which could actually make this realistic, and if I was concerned about the run past the kegerator I could consider adding the glycol chiller option.

Curious to see what others think of this madness.