New bridge opens to drivers after three years of construction