I have had sand substrate in my 120 and currently in my 55. I used Play Sand from the local hardware store. Usually around 3 dollars for a 50lb bag. It is very dirty when you get it, so we poured it into a large bucket outside and ran the hose on it. It took several rinsings before the water became mostly clear. We did sand first, saucer on sand, poured water on saucer to help minimize stirring it up. The first day or two it was a bit cloudy, but it settles. It did not seem to bother the filter at all. The result is a very natural looking substrate that our fish seem to enjoy. Especially cichlids.
White sand tends to wash out the colors of freshwater fish, I think. And is usually seen in saltwater tanks where it looks more natural. Petsmart online sells Moonlight White Sand for freshwater at $20 for a 20lb bag, though. I have not tried it, myself. But if you want to try a light/white colored sand just make sure that it doesn't contain crushed coral or things that are meant for saltwater tanks.
Not all fish will do well with a sand substrate so it depends, too, on what kind of fish you are thinking of or have in the tank already.