Rosetta is on the SL install disc as an optional installation.
To check what versions of software you have, open the System Profiler;
> About This Mac > More Info
and go to the software section (down the left side) and select Applications. That will bring up a list of all applications on your Mac (takes a little while to load, so don't panic if nothing seems to be happening for a minute).
One of the columns gives you the application type - Intel, Universal, PowerPC, (and just possibly Classic if you've migrated from 10.4)
Intel - will run only on Intel processors
Universal - will run on Intel or PPC processors
PowerPC - will run only on PPC processers or under emulation in Rosetta
Classic - won't run at all.