Co-creating water knowledge: a community perspective