Not noisy at all.  The wind has to be blowing hard to even hear a 'whooshing' sound when standing right next to it.  My pool waterfall is louder and the exhaust vents from my mining operation are MUCH louder.

The neighbors seem to like it so far.  It's fun to watch. 

Dangerous to birds is a bit of a positive side effect as they are afraid of it (I'll update if we have any injuries).  I've had issues with pigeons using my grotto waterfall as a bird bath, and my decorative owl only scares them away about 1/3 of the time (the hawks in the field behind my house do a better job).  I have yet to see a pigeon near the turbine since it's installation so that has been a noticeable benefit.

As a bit of a side note, my home is located on the path of an annual bat migration.  I enjoy watching them fly past my backyard.  I suspect their echolocation will protect them from going near the turbine, but I will keep my eye open for injured bats and pigeons.  If the turbine does injure a bat, I will explore methods for providing them protection.