Sustainable management of Mediterranean coastal fresh and transitional water bodies: a socio-economic and environmental analysis of changes and trends to enhance and sustain stakeholders benefits