What material are you working with? And, is the hose to be a drain? You can acquire a drain tap that inserts into a drilled hole. The kit has the seals and hardware;</p>
I put a stainless tap in a huge metal tank that catches water for my Tomatoes... For you to understand the concept, you can look inside a cooler that has a drain. you will see the tap has a seal and a nut on the inside. Whatever size you find you can adapt it to any thread patter. I installed a good gate valve on mine then the hose. I found a 1" rubber hose and slid it onto hose adapter at the valve. Works great...</p>