I would think that you would have a hard time keeping the sand in place unless the pond is relatively flat.

I would go with smooth river gravel if you can get it.