Aberdeen bridge reopens following death of man