If you want a dashboard widget, check out iStat Pro or iStat nano.
If you want something in your dock, just run the Activity Monitor program (in Applications > Utilities) then click on View > Dock Icon > Show CPU History. You can close the main window, and the dock will still update with CPU usage.
Gives you something like this: