A general rule of thumb is that the roots of a tree spread out 3 times farther than the canopy of the tree. You have pines and there is a 50/50 chance that they have a tap root that pretty much goes straight down. If you can find out what type of pine you have (some stay small and grow very slowly) it might not get much bigger than 25'. Regardless, I wouldn't plant any tree that close to a house, not because of the water, but because the trunk will eventually get big enough to cause other problems to the house, as well as the limbs. They will not, however, draw water to themselves like a shopvac. Shrubs are planted all the time around homes and most don't cause problems. There are a number of things to consider here: what type of shrubs, do they have aggressive roots, what type of soil, is there good drainage or is the water sitting there, how often will you have to water them. Look for something that stays small and needs littke water. Your wife can have lots of flowers and that won't cause a problem either.. just choose carefully and correctly.