We plan on putting in an orchard on our homestead. Last spring we planted a Montmorency Cherry tree (Prunus Cerasus Montmorency) which is classed as a sour cherry. I don't find the fruit to be all that sour though and you can find me right alongside the children, searching for any fruit the birds have missed.
We have one of these trees in our yard now. The cat is tethered near the tree and the kids play there as well. That also means we get a few more cherries than the birds. We've had this tree for about 4 years and get about 3 to 4 cherry pies from it (plus some eating cherries).
We first found a natural clearing in the woods where we want to locate our orchard, then we planted the tree. (My loving husband got to haul the 6 foot tall tree in its pot through the woods.)