Sand is a very popular substrate for freshwater aquariums, all but one of my tanks have sand as their substrate. My personal choices for a sand substrate are silver sand (most commonly sold as play sand) or silica sand which is often sold in fish stores as river sand. , both are inert and should not affect water chemistry, though sometimes silver sand will cause a pH spike at first if not washed thoroughly before use.
Sand is easier to keep clean than gravel and ultimately should lead to tanks with lower nitrate levels as dirt just sits on the surface where it can be syphoned or netted out easily instead of getting into the substrate where it cant be seen. The only down side to sand is that in my experience it isnt a good substrate for planted tanks as it generally isnt used at a depth deep enough for good root systems, with sand you dont really want a substrate depth of more than 1.5" or you could end up with anerobic conditions which are dangerous in FW tanks.
To clean sand just run the end of a syphon about 1" off the surface and all the dirt will lift and be sucked away leaving the sand in place.