I have never had any kind of sand, cloud the water. I have used cheap sand , pool sand , tahitan moon sand, LFS aquarium sand , onyx sand... not one ever clouded the water but if you do not RINSE it until you are blue in the face and the water runs clear from the "small one gallon sized bucket" you use to rinse it in then you will forever have a problem.
A 15lb bag of sand probably weighs 13lb's when I am done rinsing but it is well worth it.
What you need to do with sand is get the dust out of it... all that is left is basically "very" fine stones. It is very time consuming but must be done or you will never be happy with it.
If you have any mess in the water with sand I will guarantee that you took a short cut in the preperation for the tank.