Here, go to More Printers, wait until 'Searching for installed printer drivers' completes and select Canon IJ Network, which should then detect your printer. But maybe all that is needed is already included (see also /Library/Printers/Canon/BJPrinter/Utilities/) and all that's to be done is go to System Preferences, Print & Fax to add a new printer.
Given the notes I wrote down about the cd not being usable, I might have downloaded some new software then. And maybe this is also required for normal use, like to see the supply levels - but I don't see those on demand anyway, though the printer does warn me when ink or paper runs out.) (At least during installation: if not allowed, then the list for 'Canon IJ Network' in the Network Setup program will be empty. (My printer cd is labeled PIXMA iP4000R Setup Software & User's Guide, MCD 1.1, QH7-1581, copyright 2004.) Especially for those installing a wireless printer but facing an empty list for 'Canon IJ Network', here's what I've written down after installation of a PIXMA iP4000R on 10.5 Leopard, a long time ago: Not 10.6 specific, but just for the archives.