Well, the first thing that I noticed was your dropoff shape was set to defaults.

Under the "Shading" rollout, change the following:

-Set Transparency to HSV: 0 - 0 - 0.033
- Set Dropoff Shape to Cube or Sphere
- Set Edge Dropoff to somewhere around 0.802

Mess with those settings to get closer to the look you are going for

Dealing with Fluids, like most dynamic simulations, is a trial and error process, so sometimes a LOT of tweaking is neccessary.

That gave me the following: