OpenTerminalHere is a Toolbar Script for Mac OS X 10.1 and later. In Panther / 10.3, you put it into the sidebar at the left edge of the Finder windows.
When its icon is being clicked on in the toolbar of a given directory window, it will open up a new Terminal session with that directory as working directory, i.e.