What happened to the Three Sisters Bridge in Washington, DC and why was it never built?

What is the legend behind Three Sisters Island in the Potomac? It dates back centuries to when the Algonquins lived in what became DC.