Can one article be published in two different language journals? Is it possible to publish the same article in multiple journals published in different languages? For instance, I have a published SCI journal article, but I want to publish the same article in a domestic journal for a local research community as well and vice versa.

Will it be consider self-plagiarism?

How do I deal with the copyright issue, considering the publishers of the journals are different?
As I suggested in the comments:
Regardless of whether or not this is an ethical thing to do, self-plagiarism only exists if you do not state that you have published this before.
If the local journal accepts a translation of the paper as a submission and you do not break any copyright agreement with the original journal, as long as you do say that the original work is somewhere else, then it can not be plagiarism.
Plagiarism implies intentionally hiding that part of what you publish is not original at the time of publishing.