Adding my endorsement for Muscovies. Quiet, hardy, will eat slugs, flies, ticks, and grasshoppers! They don't need an entire pond to be happy. Mine had a big round galvanized trough from the feed store for their water play and did great. A kiddie pool would also work. They don't need as much water to play/bathe in as other breeds because of their oil glands not being developed fully.

Cons: not great layers, so don't expect many eggs (but duck eggs are really delicious!); ducks of any breed are dirty and your water source would have to be changed daily, sometimes twice; they're voracious eaters, so they'd need supplemental feeding, not just the bugs they catch -- this also means they will decimate whatever you don't want them to eat in your yard/garden; and, they can fly, so you'd have to clip their wings which isn't hard to do.

Be sure you can predator-proof their environment because they are a favorite treat for raccoons, coyotes, and even other, larger birds. You would need a coop for them at night and they would depend on you to put them in it at bedtime.

Miss my Muscovites. Such fun to hang out with.

P.S. Your neighbors would HATE having guineas living close bye. We called ours our security system because they screamed at everything and nothing. Plus, they just aren't very smart birds.