Timinycricket, we finally have enough threads in this forum that I can give you a reference. You should read through the following thread where the end config is a system similar to your proposal. There is a lot of good advice in here:
Mobo: I don't think you will have problems or limitations with an ASUS P5Q motherboard for gaming or components. However, give us a little time to research it.
CPU: The Q6600 got a reputation as a gamer's CPU, but those gamers were overclocking it. At 3.2 GHz OC, the cores are NOT slow! However, while that reputation lingers, the Q6600 is no longer the best CPU for gamers including those who overclock. Step up to a 45nm Core2 which uses less power and generates less heat. It's still true that a small percentage of games utilize all 4 cores in a quad core chip, but if you must have one there are 45nm quad cores with a higher base clock speed, such as the Q9450 (2.66 GHz) and Q9650 (3.0 GHz). However, these are not as inexpensive! A better value proposition would be an inexpensive 45nm dual core with a high clock speed and low power, such as the E8300 on up to the E8600.
PSU: at least 500W, at least 80% efficiency. 80plus certified a...um, plus!
Case: no, not all of those fans plug into the motherboard. Typically, Antec case fans are 3-speed manual switched fans which can run off of a 5v molex connector. 7 fans is a lot -- probably overkill for your system if you are not overclocking.