Can I provide visibility of private notes for a particular user role?

No, other roles can't view your private notes. Only you can view the private notes for which you are the author.

If you want other user roles to view your note, make sure you don't select the Private check box when you create a note.