Here's some info on power connector, you could connect you're fan to that and it would operate all the time the power is on, not very elegant, but it would do the trick.
http://amiga.emugaming.com/cd32faq2000.html#pinoutsBTW the red LED fan to match the red CD32 logo sounds as if it would look really good. :-)