A bridge which was severely damaged by the worst storm to hit the borough of Bury for decades is to be replaced.