In most practical pipes for everyday use, the flow is primarily turbulent. The kinetic energy would just be 1/2 m*v^2, where m is the mass of a section of fluid in the pipe and v is the velocity of that fluid where you picked it.
You could solve backwards for the velocity if you knew the head loss and friction factor in the pipe (can get off a Moody chart using pipe surface roughness and the turbulence of the flow). http://en.wikipedia.org/wiki/Darcy_friction_factor
Turbulent kinetic energy is particularly useful when looking at CFD turbulence models. For example, the very standard k-ε model uses turbulent kinetic energy as one of the "transported" variables representing the turbulent properties.