I think
Leonard is a stereotypical dorky name.
Leonard on THe Big Bang Theory is evidence of this.
If you are in the US, I don't think there will be any spelling or pronounciation issues.
No I don't think it is getting common.
Yes, you could still use
Leo.
ETA: to correct spelling mistakes
This message was edited 8/23/2011, 8:59 AM