You can use SiteAssist Pro to set up the general look for your page, but the javascript image zoom would have to be implemented by hand after generating your pages from SiteAssist. That is definitely something Dreamweaver is able to handle, it would likely involve linking in some external javascript files and adding some javascript to the page you apply this effect to.
By looking at the source code, it looks like it uses mootools (mootools.net) as the base javascript framework, then a plugin called frescaZoom.
-justin
