Little Rock's
Big Dam bridge:
It's not exactly an architectural marvel, but it's apparently the longest purpose-built pedestrian bridge in N. America. It was constructed over an existing dam on the Arkansas River and lights up and night. We walked across it while visiting family in AR a few years back and it was a pretty cool experience.
There is also an old railroad bridge next to the Clinton Library that was recently converted to a pedestrian bridge: