Snow Leopard is a bit snappier. Even with 32bit-only apps. It would be wise to install it on a separate partition so you can easily revert to 10.5 for apps that are not yet 10.6 ready.
I have the next model up from yours. I use SMCFanControl and CoolBook on all my notebooks. [download both from macupdate.com] And there’s no change in fans. However I don’t have the new Nehalem book yet. 8Gigs of Ram puts it on the top of my wish list, however. 
I quit CoolBook whenever I run hardware intensive apps like Zbrush, C4D, VueInf, or Photoshop, etc… But I keep SMCfancontrol running all the time at 3000 rpm or higher. Cooler Mac = longer life, especially for the battery. Fans are cheaper to replace than motherboards.
SMC is just a fan controller while CoolBook will throttle the CPU voltage. Throttling is good when running less intensive tasks as it keeps the battery much cooler than with the fans alone.
A MacBook Pro with both fans at full speed is still waaay quieter than my tower with it’s 7 fans.
