A former destroyer which played a vital role in The Falklands War and had an illustrious naval career will be scrapped.