well you can get just a cat-back, this is what i have, makes a nice noise but isnt loud, or you can get a full turbo-back system which will be louder, depending if you have a petrol or a DERV
I have a TDI so wont be loud anyway, a petrol will be louder