Water cascade animation

Hello people, id like to implement a basic water cascade coming out of a pipe while the valvle is openedand it fills a tank. Do you have any idea or a tool to do that? im thinking about playing with binded angle and position but cant find anything clean enough. thank for your suggestions in advance