I use a python water changer and while it does suck up some sand if i get to close the loss is minimal, I have a bucket under the output to catch all the sand and put it back in though.
^^^^^^^ +1 ^^^^^^^
i think pool filter sand is the best for tanks it always looks clean and light and the dirt just comes off so easily , just put a bucket and use a small siphon works great