Been thinking about that Liquid Cubed video that popped up this weekend. Gives me some simple ideas on how water could be implemented while maintaining volume. Wouldn't have waves etc but could work fairly well. Anyways back to work.
Edit: BTW should note what I'm thinking about wouldn't be as nice as theirs since wouldn't support water pressure but would support being able to drain a lake.