Batteries for your MacBook can be purchased from Apple for about $129. Other users have reported being able to buy 3rd party compatible batteries on eBay for $20-30.
I think it is unlikely that the battery is causing the fans to go crazy. Have you tried resetting the System Management Controller? That is a good first step for power related issues such as this.
Best of luck.