I assume you have the entire CS3 suite, so you would port the image into dreamweaver and do it there. You can link the entire image, or only a portion with an image map.
Well photoshop is strictly graphics software, albeit very advanced, so you cant insert a link in ps. as the guys above said, you can import an jmage into dw and link it from there using hotspots or the usual way...