1) From the Apple menu, choose System Preferences.
2) Click the panel named "CDs and DVDs" (second row named HARDWARE)
3) There, you can choose behaviors for inserting various kind of disks. In this case you'd want to change the phrase,
"When you insert a picture CD" from "Open iPhoto" to another option, like "Ignore" or "Open other application..."