Use a gravel vac, shoving right into the sand so it sucks as much as possible. Let the water flow into a very large bucket and have someone use a jug to scoop some water back into the tank so you don't run out of water. The sand should settle enough to allow water to be taken out.