Having never read the books, I'll tell you that the sex scenes in the show are anything but non-explicit.

One of the reasons I was able to keep watching the show is that the first thing Sookie does for Bill is save his life, and the second thing she does is make fun of him for being called "Bill". Which I think is funny. But in the show they really play up that what draws Sookie to Bill so strongly is that she can't hear his thoughts, and that if she ever really wants a relationship with someone who won't drive her insane, it will have to be him (or another vampire).

I'm definitely a vampire (non-Twilight, obviously) girl, though, so I am biased.