To expand on Keiths excellent sugestion, you may wish to consider the available range of Sorbus species. There are a number of attractive and variable forms in nuseries and garden centres these days. I think some of them are perfect for smaller gardens.
In my garden there was a small Rowan growing in the rear boundary when we moved here seventeen years ago. It has never really taken off and is currently 12 feet high. Poor stock perhaps or a wild tree that is on poor substrate. I then planted a Swedish Whitebeam to one side of it that makes a magnificent sight when the leaves burst from their buds. This tree has filled out well and hides a view of a garage.
This winter I have planted a specimen of Sorbus "Autumn Spire" primarily to fill a gap where an errant lilac once stood. I chose this species as it is a fastigiate clone of the famous "Joseph Rock" and it has a columnar habit and should not spread. It also has a good colour in the autumn and fruit for wildlife. It is growing between the Swedish Whitebeam and a "Pauls Double Scarlet" Hawthorn.
Have a look at Trees for Life on
Trees for Life - Frank P. Matthews Ltd.
They grow some good stuff and I have no connection with them!