Go for some nice software or VST plugin, for example Addictive Drums is amazing; but I believe there are at least a few of them.
Run it through any DAW that is VST host (Logic, Pro Tools, cubase etc...). This way you have one DAW which allows you to both play your drums software and mix your tracks.
BTW, there is also FREE route
here you may find few nice drum multisamples http://bedroomproducersblog.com/2010/06/24/free-sample-shootout-2-acoustic-drums-full-kits/
and you need some software to work with it, but there are a few free applications. For example, I use Mulab as a free DAW and VST client, but you'll need some sample player that allows playing multisamples (there are a few free ones). It's simpler to just buy VsT like Addictive Drums which have samples already implemented. Free route requires some more searching and tweaking than when you buy what you want, but it's free. At the website I posted above you may also find links to some other free multisamples, like Rhodes, or VST effects.