Understanding Freshwater Ecosystems and Human Health Implications in Recreational Water through Microbial Characterization, Source Tracking, and Sediment-Microbe Dynamics