I thought the blood fountain was pretty - until I drank from the damn thing and was told I had drunk somehting along the lines of tainted ancient blood. Even as a vampire that didn't sit well with me and I didn't think it was so pretty afterwards.
So, is the blood in the blood fountains the same blood that's being recycled over and over? If so, that's pretty disgusting, even for a vampire. After a few days that blood would taste pretty bad.