This is just common sense (well, to me anyway). Assuming all the energy gets transferred into heating the water and none of that heat gets lost, then yes, all the kinetic energy heats up the water. But this never happens in reality due to the nature of materials and their properties.
In real life, some of the energy is given out as sound (which is how you hear the splash), and as energy in the form of heat or other energy forms (can't think of any others).
If you drop the water from a bowl into another bowl and none of the water splashes out then some of the heat will be lost into the bowl and then through the bowl and into the air, and so on. You'll lose some energy due to sound. In fact, I imagine most of the energy transferred into the bowl is kinetic energy which then runs through you if you're holding the bowl, or the table if the bowl is resting on a table. Then the kinetic energy the bowl gains immediately transfers into the ground, which is similar to my next point...
If you drop water onto the ground then I think most of the energy will be lost in the Earth, i.e. your dropping of the water will heat the Earth up slightly and give it some kinetic energy. This "heating up" or "energy transfer" of water to the Earth is indirect and assumes the Earth's crust is rigid to some extent (I think). One litre of water dropped onto the ground might cause the Earth to heat up by somewhere between 10^-20 to 10^-50 degrees or so. i.e. not very much. However, most of the energy given to the Earth by the water will be kinetic. Similar to the transferred heat, the kinetic energy will dissipate into the Earth, actually moving the Earth slightly. However, since the Earth is very large and spherical, someone on the other side of the Earth will roughly balance out
your actions, and even if they don't your effect on the Earth will be very insignificant.
This is common sense...
For precise calculations you'll need to know things like the material of the ground (and the material's density and the speed of sound through the material), the bowl, the Earth under your house, the height you drop the water from, the amount of water can be found by, and so on...