It depends on the country you get your phone from. I can choose from 4 different camera shutter sounds on my N80, or silence it completely.
EDIT - on my N80, the camera does not make a sound when keypad tones are set to off (and they are so irritating I'd never have them on anyway)!