I FINALLY got a hold of someone in Mebane after copious messages and emails. Essentially, within the city limits, chickens are allowed and roosters are allowed but discouraged due to noise ordinances. Neighborhoods are dependent on covenants, of course.
It turns out my neighborhood went through three different builders, and the second two created covenants but never registered them. The agent spoke to an attorney who said that if they are not registered, they are not enforceable.
So it looks like so long as one has nice neighbors, chickens and roosters are just fine!
I'd be curious as to your setup - coop, etc. Outside the city limits where I live now, I have a fenced in backyard that they roam in all day and are penned up in a smaller kennel + nest box at night. The property I'm considering is not fenced, so I would have some constructing to do. Of course, if this does go through, I would like to be a courteous neighbor and avoid any noise issues, as well.