I have been fortunate in that I own land and also rent some small paddocks. Round here farmers tend to hold on to their land, and then when retiring or downsizing, put it up for sale by tender, to get the top prices.
There are down sides to having land of your own - the cost of maintaining it, as in fencing, weed control, drainage etc. etc. are very high, and we find there is always something to do and pay for. A friend of mine is moving,because she said her 3 acres is no longer a pleasure - its costly to keep in good order, and her other half resents spending his free time maintaining it!!
As to keeping animals and making a profit .....with the price of feed and fodder and vet prices etc, my finances are well in the red. Last year was a terrible year for us, losing numerous goats to various things. Our worst year ever. That is why we are not breeding livestock this year, and trying to downsize in numbers. Hopefully a better bank balance and not working ridiculous hours in all weathers
I would not discourage anyone from having a go at smallholding ....far from it. All I would say is, start small, you can always increase as you gain experience, and get more land. And you have to be prepared for the heartbreak of illness and death, as well as the joyful occasions.
Do hope you find someone to help/share your idea with. I am sure there is someone out there looking for a partner to start their new venture.
Perhaps you could offer to help on a local smallholding, to gain experience, and make sure its definitely what you want to do?