Forget the big box stores if you can for the parts. Remove the drain plug thats in the cooler (if it has one). They usually unscrew, sometimes it's hard getting a grip, but it's not really useful to you anyway. Take some measurements for the diameter of the hole and the thickness of the sidewall. IIRC, I ended up getting 1/2" pipe fittings. Ended up with stainless pipe and lead-free brass valves. Used stainless washers, a piece of thick cut gasket rubber stuff and some O rings to make the connection through the side. Inside I took a stainless braided supply line (make sure you get actual stainless braid, most of the braided lines at the box stores are nylon and useless for our purposes), cut the ends off and stripped off the braid, then used a hose barb fitting on one end and a PEX tubing plug on the other. A stainless bolt would work too. Outside got a hose barb after the ball valve. I'll have to look, I have some pictures and video around somewhere.