On a person it just sounds ridiculous and painfully whimsical, like a little elf or fairy as a mascot for toilet paper or something. Piper Papre or some such.
My mother and stepfather did have a cute little dog called Penny Piper. They didn't plan to call her that, but it just stuck; her mother was Penny and her father was Pied Piper.
Before you criticize a man, walk a mile in his shoes. That way, when you criticize him, you're a mile away and you have his shoes!
Steve Martin