You don't even need special software. Just use the display tab in system preferences and set the rotation. This is available if your video card can handle driving the display in that way.
I have a GeForce FX 5200, looks like it doesn't support rotation. Does anyone know which cards do, or if you can see the rotation option in Sys Prefs, please tell me which card you have.