Canister style exhausts tend to be louder than the standard shaped muffler (due to their straight-thru design), but generally, most aftermarket full cat-back exhaust has a nice tone. Most of the time a "fart can" sound is coming from a universal exhaust with poor piping under the car.

Just get an exhaust that was specifically made for your car with mandrel bent piping and you should be gravy.