Get a 2 inch inside diameter pipe, crush bent is fine, a Magnaflow muffler same diameter. They have 11, 14, and 18 inch (length) mufflers. The bigger the quieter. They have shiny stainless steel if you care how your muffler looks. Get a Cherry bomb resonator, same 2 inch diameter, available at Kragen etc. Go to a local muffler shop, not a national chain. Your final price should be under $200.
This exhaust will sound deep under hard acceleration, not too loud, and will be quiet as stock while cruising. And best of all, it will perform well.
It's that or you can get too large of a diameter, too expensive of an exhaust, and get that buzzy ricer honda sound that only performs well in the high RPM where you rarely drive.
Unless you have a turbo or a 1.8 with cams, 2 inch exhaust will make for a faster car.
I have a question. On that exhaust pictured, how does it avoid the fuel tank? Are you supposed to get a fuel cell?