http://img526.imageshack.us/img526/4740/proudspirecrypt.png
Basically it will be a secret door entrance on the base level of Proudspire manor, a similar set up to the blades hide out at river wood. The closet/secret door with a have stair case that will lead down to the crypt were there will be a coffin for your vampire character to rest. The coffin will set on a tiered floor kind of like it does in Alva's cellar.
Alva's Cellar
http://img201.imageshack.us/img201/7130/2012071800002.jpg
I'm not advanced enough to make this happen yet, I can help with testing if a talented modder wants to take up the mantel. I have played through the DG dlc and the castles are not really that good imo, I still think the player houses are better I just want to make Proudspire a little more fitting for my vampire lord once Dawnguard comes out.
p.s. I might even throw in a copy of Dawnguard to sweeten the deal

