Using awk:
awk -F', *' -v OFS=',' 'NR==FNR{a[$1]=$2;next}NR>FNR{print $0 a[$4]}' CountryCode.csv ListIPv6.csv
The array a is filled with lines of the file CountryCode.csv and then the other file is displayed together with the entries of the array.