The water level in sandpits without a liner will follow the rise and fall of the water table, if there is a river nearby it will rise and fall with the river level. If you do add a liner do you have enough drainage area keep it full with rain water, is pumping water an option? If you don't want to use a liner can you dig the current pit deeper to allow a cushion for when the water table is low?