As sbkiller mentioned, you will either put the javascript code in your theme.html file or in a custom block.
If you are wondering where to get such code, there are many free and commercial menus available. Before spending any money, you might want to check out Dynamic Drive.
Here's a link to their menu scripts:
http://www.dynamicdrive.com/dynamicindex1/
Hope that helps.
Good luck!
John