If you clean it good before you put it in, then it will be fine. Play sand is cheapest (about $5 for 50 lb) but takes a long time to clean. You will almost definitely get some cloudy water with it, regardless of how long you take cleaning it. On the other end of the spectrum is something like Tahitian Moon Sand. It is black and more expensive (about $20 to $30 for 20 lb) but is a breeze to clean as it really doesn't have much dust in it. It settles almost immediately so you don't have any clouding. I have it in 2 tanks right now and love the way it brings out the color of my fish and the plants.does sand make the water more cloudy than gravel?
i heard the silt can cloud the water