Sadly I'm some years away from having lived in Edinburgh but The Royal Oak in Infirmary Street was good for music 7 nights a week from about 8.00.
The Edinburgh Folk Club in The Pleasance happens on Wednesdays. It's not a singaround but floor singers are welcome.
Enjoy your visit.
Eddie