Ahriman
Tyrant
It sounds like my system is basically what is being implemented, but with an increased maintenance cost if your resource supply falls below the number of units you have that need the resource.
http://forums.civfanatics.com/showthread.php?t=356391
Huzzah!
No word on whether buildings can consume resources, but I'm sure that could be modded in.
http://forums.civfanatics.com/showthread.php?t=356391
Strategic resources are handled differently. There the quantity is very important. One iron deposit, for instance, will only grant you the right to build and maintain, say, five iron-based units. You can't build any more than that until one of those units dies (or is disbanded) or you get access to more iron. You will be allowed to keep those units in the field if your resource is pillaged, but there's an additional maintenance burden and you won't be able to replace them if they're lost.
Huzzah!
No word on whether buildings can consume resources, but I'm sure that could be modded in.