Presuming you mean
this model, I would recommend upping the RAM to at least 8GB (it's a Mac Pro, after all) and running the latest OS, which is El Capitan (OS X 10.11). If you have Snow Leopard installed, update it to 10.6.8 if it isn't there already, then use the Mac App Store (and an Apple ID you'll need to create if you don't already have one -- your iTunes login will work if you already had that) to update to El Cap.
There's no reason not to update a machine that is capable of running El Capitan, it is very fast and will work just fine with that machine. Snow Leopard was great in its day, but it is NO LONGER SAFE TO USE ONLINE. I can't stress this enough -- it hasn't received any updates in years, and more and more programs won't work on it.
With the El Cap install you'll get all the basic programs, though you may need to run the Mac App Store's software update a few times to get everything. Some programs that come standard on new Macs, like iMovie and such, may need to be purchased -- but they are cheap and you can just buy what you need. If you slap some SSDs in there you'll get great performance out of that machine, though of course the newer Macs are waaaay quieter!