My first three guesses would be:
- Faulty bearing (water pump, belt tensioners, AC compressor, as mentioned above)
- Engine Mount
- Loose belt
Anything that could wiggle or bump at idle that would smooth or balance itself out when the engine speed is increased. Does the noise come or go when you activate the AC?