A Herefordshire bridge has reopened after a three-week closure, with crucial works now completed.