I've used InsomniaX to keep my Mac from sleeping. It works under Leopard.
I'm still unsure if anyone even answered the OP's question...
Does a download stop if the Mac is put to sleep via lid closed? Or paused? Or does it still go? That will determine if the OP needs InsomniaX or not... XD