In Irish it is Ni (with an accent over the i) pronounced like "knee"
However, if the actual surname begins with a vowel sound it becones Nic (no accent on the i) pronounced like "nick"

I'd guess that Scots & Manx Gaelic are similar, but I don't know