Bristol City Council was preparing to spend millions fixing Pero’s Bridge before dramatic collapse