Looks like you are confusing things a bit.
Basically, on a hardware level it doesn't really make much of a difference which type of drive you buy, all scsi drives, be it a single speed sony or a 40 speed plextor use the same "driver".
You need a CD Filesystem, AmiCDFS is free on Aminet or C= gives us one with WB3.1 and up.
To make the drive work on a hardwarelevel the best (read fastest) option would be to connect it to the blizzard.
the scsi device (1230scsi.device) is ROM based and does not require any additional drivers (the supplied disk has utilities on it). All you would need is to set up a filesystem.
Digging deep in my memory here, been off amiga's for 6 years now, just coming back....