I came across @RasmusA's design, which featured a straight piece extending from the rain barrel. While the concept worked well, I felt that it didn't have the best aesthetic, especially for a more permanent installation. So, I decided to modify the design by positioning the nut on the inside of the tank and adding a bend on the outside to accommodate a standard half-inch garden hose. This resulted in a cleaner and an in my opinion better functioning part.
For the through-hole, I utilized a standard 25mm forstner bit, with the nut and threads both having dimensions of M25x1.5mm. I would recommend some teflon tape for the threads, to make sure they seal against the barrel.
I have printed mine in PETG, with the nut being printed at 103% scale to have a nice fit. Your milage may wary depending on your printer. What I would also recommend for the main part, is that you print it at an angle shown in the pictures. This will give you better strength in all the directions that it will experience forces.
The author remixed this model.