Right... almost. The Coriolis Force will show up anytime an object has a velocity ("v") that has a component perpendicular to the vector sticking out the axis of the North Pole (what physicists call the "omega" or angular-velocity vector). So moving in any direction* (north, south, east, or west) there will be some perpendicular component between the two. F goes as -(omega-cross-v), for the math nerds.
So yes, if the water is stationary in the tank, there is no Coriolis effect; it only shows up if the water is flowing. The "v" in the equations refers to the velocity of the water within the tank relative to the Earth, not the tank itself; the tank is presumed fixed to the spinning Earth. Or there doesn't need to be a tank at all (as with global air masses and currents).
*... Except at the equator, where if you move due north the "v" vector and the "omega" vector are parallel. Technically, if you move east or west at the equator, there *is* a Coriolis Force but it will point straight into or out of the Earth, and so you won't feel it as a "sideways" pull like at other latitudes. Depending on your latitude and what direction you're moving, some component of the fictitious** force vector may point into or out of the sky, and people usually don't count that as part of the "Coriolis Effect" that makes things swirl/pull sideways. [All of this is easier if you get a basketball and use the fingers of your right hand (locked in the "right-hand-rule position") to figure out some vector cross-products!]. But in any case, for the slowly-spinning Earth, it's a very small effect, way too small to make a difference in a sink or a toilet, as others have said...
** The Coriolis and Centrifugal forces are called "fictitious" forces because they are not really pushes or pulls from anything, but just the consequences of living in a rotating reference frame (in our case the spinning Earth).
I was being just a bit facetious about the "Earth spinning up/slowing down" angular acceleration thing... that effect is truly tiny, probably not even measurable. But if Earth did have a sizable angular acceleration, it would create all kinds of additional fictitious forces (besides just our two favorites, the Centrifugal and the Coriolis), and the world would be an interesting place. But that's a different topic.
P.S. I watched the Aussie toilet here carefully, and it was mostly just a roil of chaos... but if there was any rotation to the flush, it looked CCW (Northern-style) to me.
I'm still pretty jet lagged.