Cookie I feel your pain!
I'm in the UK with our tiny plots and expensive property.
We lived in a Victorian Terrace in the middle of town with a tiny back garden for 17 years, not enough space to swing a cat but I dreamed of having chickens
Last year we sold our beautiful but tiny terrace and bought a house with a much bigger garden. The house is probably a bit small for us but it was the garden of my dreams and soon it will be just my husband and I. We've got the chickens of my dreams, the ducks of my daughter's and a small area to grow veggies.
We are still in a town and my next dream is to get a small holding but for that we would probably need to win the lottery! Cheapest I've seen in my area is £1.3million for a few acres and a small house. I'd consider Wales or Norfolk but husband won't consider moving out of our immediate area

so I understand how difficult it is for you.
You can do it in a smaller area you just need to consider your options, call ducks are small so may suit you area (which sounds pretty big still for UK standards).
If I was younger I'd move country, maybe Portugal.