Sand is better because it is denser and does not wet your product if it gets leak from the tank and does not make a smell. On the other hand, water will make everything wet and keeps on leaking from the tank. And water may give off unfavorable smell if it stays in the tank for a long time.