Are you looking for a point and shoot type or a model that accepts interchangeable lenses?
Almost all of the current point and shoot models make no noise when taking pics. All of the name brands have very good models that have most of the capabilities of traditional 35mm SLRs (manual settings, program settings, time exposures, etc.) and have quality lenses with up to 6x optical zoom (digital zoom is available beyond that, but image quality begins to degrade). That is in addition to the digital capabilites. If you want the flexibility of using interchangeable lenses, then you are talking bigger $$$.