SystemC has a synthesizable subset can be called RTL SystemC .. you can use a tool called (sc2v) to translate this RTL to verilog which can be synthesized to FPGA. Another thing, is that if the FPGA includes any processor core like (microblaze), SystemC can be used as normal C++ for programming this core if u have the proper compiler.
An example of complete system design using SystemC is avaiable on opencores. The guys used (sc2v) free tool to convert their systemc to synthesizable verilog.
About the tools, if you use Linux the best thing is to build the downloadable SystemC libraries on GCC. then just compile systemc as simple as compiling C++.
If you are using Windows, you can do the same on Cygwin, or use MS VC++ 6.0.