Elder roots go up to 40 feet and will get in your foundations / drains.
A no-no in a small front garden I would have thought, particularly if the kitchen drains are "just there".
Anything tall enough to be in front of upstairs windows is going to be a problem in a small front garden. Ornamental cherry would be about the only thing I'd consider, or Amelanchier.

Paws