Happily, there is a solution to this problem, and I am benefiting from it now!
This problem - not being able to load a working driver for Adaptec SCSI cards that will work with Leopard, e.g. 10.5.6 - has been noted by quite a few others.
There is a (now-closed) discussion on this on the Apple forums at:
http://discussions.apple.com/thread.jspa?threadID=1299728
The solution mentioned there does work: on another partition or drive, boot up into OS 10.4. Run the Adaptec driver install package from there, but choose your 10.5.6 partition/drive to install onto. Finished. Works perfectly.
It is noted that - if you are in 10.5.6 and just run the available Adaptec driver install package, you will get the following: "Install Failed - The following install step failed: run preinstall script for Adaptec SCSI Card ...". However, if you install from 10.4 onto your 10.5.6 partition, no problem. The solution produces a proper read/write SCSI interface (before this approach some people had ended up in a read-only situation).
FYI here is the same issue and solution as discussed on Accelerate Your Mac (skip down to "Driver Install Tip for Adaptec SCSI card/OS X Leopard Users":
http://www.xlr8yourmac.com/archives/mar08/032708.html
So far as I can know, the Adaptec 29160 best uses the v1.3beta driver, and the 2906 needs the v1.1 driver. If there are more up-to-date drivers, let me know. The 2906 had a 1.3 driver, but that was OS 9 only.
Good luck and enjoy. I'm very happy to have my scanner back. Now if I can just remember this approach when we get Snow Leopard!