I'd get some sort of cat-back to compliment the header. Just make sure it has a decent sized resonator on it to reduce the sound if your concerend about it.
Nissan Forums is the go to place to talk about your favorite Nissan model, including the Rogue, Maxima, Altima and even sports cars like the 370Z and 200SX.