Sorry to be chiming in late, this just happens to be in my area of knowledge and I didn't see the thread...
Are you only concerned about footfall noise? Do you care about airborne noise as well, such as voices, TV, etc?
Can you list your current floor/ceiling assembly, such as:
finished surface (carpet and pad, tile, hardwood)
plywood or OSB subfloor
2x10 joists at 16" o.c., or open web wood joists @16" o.c.
Also, you mentioned that you are planning to put in wood/tile in certain areas...are these areas directly above where you are finishing out the basement?
There are two ways for the noise to get from one floor to another. In multifamily(apartment/condo) buildings these are rated in terms of Impact Insulation Class(IIC), and Sound Transmission Class(STC)...Footfall noise is primarily related to IIC. It needs a different solution than airborne noise. The international building code has requirements that new construction must meet for STC/IIC, just as it has structural, electrical, plumbing requirements as well.
While sound insulating batts (insulation) do help the STC rating of an assembly to some degree, it has been well documented that insulation does very little to increase the IIC of a floor/ceiling assembly. Furthermore, adding additional layers of drywall (or dense drywall products, such as quietrock) don't do a whole lot either for IIC. Neither does a dampening product in between multiple layers of drywall. And fiberglass ceiling tile, while it does absorb sound, it is not good at all at stopping sound. Many generic ceiling tiles, and certainly plain gyp board, has a lot higher CAC rating than lay-in fiberglass tiles.
Depending on the structure of your assembly, and the finished floor material, you can have one heck of a problem trying to decrease impact noise. The only way to make it better is to isolate the top from the bottom. This is usually accomplished through the use of resilient underlayments on the topside underneath the finished floor, and/or resilient channels or mounts on the bottom side between the structure(joists) and the drywall.
In addition, if you are on the perimeter of the building or near walls that extend through both floors, you need to isolate the ceiling and floor from the walls, with the use of non-hardening caulk, etc. Any rigid connection to the structure will 'short circuit' your assembly, and reduce the overall performance.
If you give me a little more info, I can try to help out with some product info, and general recommendations...bottom line is that you will need to spend some additional money, and likely take some more time during construction to ensure that little things are done correctly.
Even then, if you have hardwood floors or tile, and wood joists, you will still be able to hear the people above...just much less noticeably.
