Yes, it is single-use. It has the ability to conjure a dremora valynaz. I'm not sure about the difference between a dremora lord and a dremora valynaz, but I can assure you they are both pretty powerful.
You might want to be aware of a certain bug regarding the Sanguine Rose, which renders it...