I'm looking for a Russian language pack for Heroes of Might and Magic III.

Yes, but the mod doesn't translate the SoD campaign. Where can I find a Russian translation for the campaign?

You can use the Bukka localization (instead of SuperPack_Rus).
Here's a plugin to adapt the HD mod specifically for Bukka:
http://www.handbookhmm.ru/forum//topic/529/