I think you need to add new enum column in note table with values ['private', 'member_only', 'public'], Then when the user create note he can select type of this note. Then you can show note based on this new column for example:
<!-- when note is private -->
<xf:if is="$note.note_type ==...