Most people don't use buckets with spigots for this reason, though they can work.
One major issue is tightening it down too much. If you put too much torque on the o ring will deform, causing a leak. It is better to just hand tighten without cranking it as hard as you can