We were talking about this at Astrofest but I don't recall hearing of a ready-made solution. The Astrotrak people were thinking of it but I don't believe they had actually got as far as designing something.
In practical terms, the density of rock is about a third that of iron, and wet sand about a quarter.
Here is a list of the densities of various materials. If you are just balancing a camera, the weight doesn't need to be anything like as much as for a telescope, so probably it would work.
It would be perfectly feasible to make a half-decent device to balance a camera from a suitable tin, but it would need a fair bit of effort so that it could be clamped to the shaft and could be easily filled. The lash-up system you suggest might just work and all I can suggest is to try it and see. I only have an EQ2 here so anything I devise would probably not work on your EQ1. I assume your EQ1 is motorised otherwise there isn't much point.
Of course what you need is to be able to borrow a NZ counterweight when you get there. Or the whole mount.
Robin