2 PCS Rain Barrel Bulkhead Fitting kit with Plugs and Hole Saw Tool, 1 Inch PVC Spigot Connector Kit for Rain Barrels Water Tanks Pools Aquariums Tubs (Bulkhead 1 Inch)

Drill a bigger hole and install a bulkhead fitting that is bigger than the hose, say 1". Then add a valve and a 90 like a spigot. You can get a hose nipple if you want a hose on it, or just put the can under and fill it. https://www.amazon.com/Bulkhead-Fitting-Connector-Barrels-Aquariums/dp/B0BMLBWBY8