It'll be a one time cloudy deal usually. I bought 40 lbs of Playsand at Canadian Tire for $3.44.. make sure it's not fine fine grain sand. Mine is just smaller sized than a pea.
I put 25% of it in a bucket and rinsed it out well, and stirred it up with my hands until the water flushing out was clear, or mostly clear.
I just dumped it all in, and it was faintly cloudy, like you see in the pictures. But it wasn't terrible. Each time you do a gravel clean it'll get less and less cloudy as the small particles are sucked up.
In my old 33 gallon, I had used Reptisand which is very very fine, like beach sand fine. It was terrible to clean, and when I finally took it out of my 33g, it had a thick black layer of dead plant and fish waste. I'll never use that find sand again.