Get the builder to discount the home as much as possible and negotiate for the builder to plant some trees or put up a privacy fence to block it from view if possible.
The second most frequent complaint I hear about these ponds is that they draw insects.
The bottom line: I would make sure that you are getting some fairly significant pricing concessions on the home, simply because there is a perception issue at hand, and that will eventually affect you on the resale of this home. That means that future buyers will have the same concerns that you are having, and (in order to sell the home) you may need to be less expensive than the houses that are farther away from the pond.
The rule is this, if you have to ask about the pros and cons, then you likely shouldn't buy it... UNLESS
there is a significant price differential, but then again, remember you'll have to pass that along to the next buyer.