If I was building one, I think I would cut a square notch in the drum and a key way in the chain sprocket that goes on the drum, and put a key in that clamped on sprocket.
That way it couldn't spin on the drum. If you cut a shallow squared off groove for the key in the drum, I don't think it would hurt the drum or effect how the cable spools.