Play sand is cheaper by a long way than aquarium/pet store bought sand. Pool filter sand is also quite acceptable & usually very cheap. The stuff you get from aquariums will cost you a bundle more. Aquarium sand does come in different compositions though to suit different types of aquariums, eg crushed coral sand for high
pH tanks. You can also get a few different colors from most aquariums so you don't have to have just plain white.
Sand generally requires a little bit more maintainance than gravel does. It compacts quite easily & because of the lack of water flow there is very little oxygen in the substrate. This can lead to what is called anerobic conditions & gases that are poisonous to your fish & plants can develop. It is easy to avoid these gases becoming a problem by giving the sand a gentle stir through, right to the base glass to release the gases & allow oxygen to penetrate. There are some snails that dig around in the sand & help with this as well as many fish such as Khuli Loaches. It's not as bad as it sounds at first though & so long as the maintainance is done properly & regularly sand makes an excellent substrate material for many tanks. Sand also requires being a bit more delicate with vaccuuming as it is easily sucked out of the tank when using a siphon. The trick is to hold the vaccuum just above the surface of the sand so that debris are picked up in the siphon but the sand is mostly left undisturbed. Debris will also be more visible with a sand substrate as it tends to sit right up on the top instead of breaking down & into the spaces between particals. Personally I prefer to use gravel substrates as they are easier to maintain in that the gases have a much harder time forming because water travels through the gravel much easier & supplies oxygen to the bacteria that will form in there. Alot of my preference is because I have alot of tanks & it is quicker & easir to maintain for me. Gravel substrates are an excellent medium for good bacteria to colonise. These good bacteria are usefull for helping break down fish wastes.
How much to use depends on what exactly you want to have in the tank. If it is for fish only then about an inch of substrate will do just fine. If you want to have live plants though you will need to have a deeper substrate of at least 2inches, maybe even more.
I would need the footprint size of your tank before I could recommend an actual amount in weight. This will also depend on the partical size if you choose to have gravel rather than sand. The larger the particals the more air there is between them & the less substrate material you will need. You don't want to go too large with gravel though or lots of excess food & other wastes will get trapped down in it where you can't easily siphon it out. Partical sizes between 3 & 8mm are best for using gravel & the largest partical size you can get for sand.