I doubt a water smoker is going to get hot enough to melt sand. I've
heard many people on here using sand before without any problems. I
personally piled my water pan full of "lava rock" or whatever they call
those briquets that people use for heat retention in gas grills. But I
think sand would be OK too.