how do i hire a musicians for my lounge in late night?

I don't think you need to hire one manually, you just put in a piano, assign the place as a Lounge (in Edit Town mode) and when you start the game a NPC should automatically show up to play (during the hours the bar is open, of course).