Most Civics and other honda's have an open slip differential, which is why when you peel out only one wheel spins.
With a limited slip differential, the front wheels lock together and will spin at the same time. It helps a lot when powering out of corners and launching off the line.
As for your integra, a First Gen (SiR-I) B16A w/cable tranny should fit right in.