My mother's name is
Nicola, so I've grown up hearing NI-ko-la and hearing her complain about people that use the other pronunciation :-D
It's a very English pronunciation and she's from England - I suspect the US pronunciation has been influenced by the Spanish pronunciation, which is the -
KOLE- one.