I'd second the vote for Fruity Loops - great cheap program and there are a ton of free samples available all over the net. Fruity affords a little more flexibility a little easier than Acid in my opinion.
I believe however, that the best sounding and most realistic drums on a computer will require a MIDI sequencer and some soundfonts (I'd highly recommend those from
Sonic Implants).
Good Luck!
Randy