Yep. You need to have it runnning natively and have 3D acceleration.
Beryl and Compiz will work best if you have a Intel onboard video card or a Nvidia video card that is supported under the 9xxx drivers.
With ATI video cards you can get Free software drivers that work acceptably well for most (not all) R200, R300, and R400 series video cards. These support AIGLX and therefore Beryl and Compiz Free software drivers do not work R500 series video cards.
You can tell if your using a R500 series video cards because they are all numbered above X1000 in their names. So like the X1300 is a R500 card. The proprietory ATI drivers work with most R500 series video cards and they support R300 and R400 series video cards (dropped support for R200). But ATI proprietory drivers do not support the OpenGL extensions needed to support AIGLX. Without AIGLX you will be restricted to only using XGL, which isn't as nice.
If you want to try Compiz or Beryl your best bet is going to be Ubuntu Feisty. Keep in mind that Beryl is BETA-quality software. It is NOT stable and may cause some issues. But for most people it does work ok.
Also Fedora or OpenSuse are good choices.
Be sure to read any aviable documention on which distribution you choose. It is VERY usefull and will have guides to dealing with most common issues and hardware that people run into problems with.
Ubuntu and others have very good Ubuntu-specific forums and faqs. Take advantage of it, search through the forums if you have problems. Chances are that somebody else has the same problem and they already figured out a fix for it. Make sure that anything you find applies to your specific version.. Fedora and Ubuntu release new versions every 6-8 months, so a lot of stuff may be out of date.
On youtube you can find a crapload of videos and such things.
Beryl Videos:
http://video.google.com/videosearch?q=b...client=firefox-a&rls=org.mozilla:en-US
fficial&um=1&sa=N&tab=wv
Compiz (mostly older. Pay attention to the dates as it's been around longer)
http://video.google.com/videosearch?q=Compiz
Beryl is a fork from Compiz. So they basicly do the same thing. Compiz and Beryl are now merging again, or at least are trying to.
Compiz was created by people working for Novell by the same people who made XGL. And you can find it aviable under Suse.
Metisse is favored by Mandriva. I think it deserves more attention as it's doing very creative things that are not possible under any other OS. I don't know how well it's all supported under Ubuntu or Fedora though.
http://video.google.com/videosearch?q=Metisse