I don't think it is unusual at all. In fact, it is getting common. I'm in the Midwest and know 3 little girls with this name. Plus it is the main character's name on Orange is the New Black and with the popularity of the show I think it will be used even more.
Piper reminds me of not so nice things. Let's see, smoking pipes, plumbing, the pied piper, I suppose bag pipes are ok. It's just that none of these are what I'd want my daughters name associated with.
Re: Piper??
Baby Name Popularity by State
C+C born June 2011
Surprise! H born Novemeber 2012
Baby #4 due September 2014
First BPP 1.24.14
EDD 9.26.14
Baby Cooper John born on 9.24.14 6lbs9oz