Official investigation strongly criticised how the UK's intelligence agency MI5 handled the double agent during the Troubles in Northern Ireland.