I haven't been there and am not sure it's still even open, but check out Le Piano Noir, 44 Front Street, open Wed-Sat.

Trying to think of others, but most places that have music have keyboards, not piano.

For live music in general, check out the Facebook page SXM Live Music. It's updated daily.