openSUSE 10.3 will ship with Compiz-fusion. On openSUSE 10.2, you'll be able to run Compiz-fusion as long as you follow the steps that Moosy provides for you.

Personally, I'm satisfied with my current Beryl setup so I'll wait until the first openSUSE 10.3 Beta arrives (09/Aug/07).