How to create a hidden plug for PVC pipe
Given all the  ideas, the obvious solution would seem to be don't use sand.

Instead, fill the bottom pipe with cement.  Or fill it mostly with gravel with a few inches of cement or silicone sealant to hold the gravel in place.