From a surname which was originally given to a person who played on a pipe (a flute). It was popularized as a given name by a character from the television series 'Charmed', which debuted in 1998.