Ability to increase humidity if it is an issue. Depends on the mechanism for how the water is discharged as far as vibration. I agree that vibration would induce stress.
Clean up would be like any other tank item, its fair game!
The other benefit I can think of is that circulating water would keep the water source from becoming tepid. The con would be if the snake did urinate or defecate then it could make its way into the mechanism or pump and it would be hard to clean that out thoroughly (introducing bacterial buildup which may harm the snake).
Hope that helps!