I think its a cute idea but probably not super practical because of the dirty water. Youll hear that a lot. Also snakes do eat fish... Ive seen it...
My fantasy is to have a bedroom set up dedicated to a big boa (that I don't have right now) with a pool for a water dish and all kinds of impractical fun stuff. But its probably never going to happen.