Figured I ask for advice before I spend days trying to solve this on my own.

I'm setting up a scene and need to animate water running from a faucet. Not just the constant running but also when its turned on and off.
Besides this I will have a bucket with an overflow of water animation.
I am not sure what would be the best approach to do this.
Any advice appreciated.