Advanced water filtration systems