Recasting an industrial and underutilized waterfront into a bustling urban destination through a feat of design and engineering