
I don't know where you live in Yorkshire so i don't know how noisy, near to motorways you are etc.
Personally I wouldn't live in Dundee city itself. I live to the west of Dundee in the area that's know as the Carse of Gowrie and that's where I'd be looking to buy property if you have a good amount of cash to spend for something for horses. The houses in this area will always sell again. And you've a good link road in the A90 if you want to get into Dundee or Perth. Only 45 minutes from Edinburgh, an hour+ from Glasgow, same for Aberdeen. The rush hour see's you stuck in traffic for no longer than 15-20 minutes if you're unlucky. Dundee does have the 2nd highest council tax banding in Scotland, something to consider.
There's good areas of woodland in and around Dundee & Perth for dog walks. I would say more to the west side than the east side, property in Carnoustie/Arbroath/Forfar etc. is a bit cheaper but lacks what I would say good dog walking areas, more agricultural land.
The weather is probably like Yorkshire, when it's good it's great, when it's skanky, it's skanky!
The
TSPC will have a list of property currently for sale so you can check what you get for your £'s. But remember it's 'offers over' here, so a house selling for £160,000 means the seller wants more for it and sometimes it can go for £20-£40,000 over the o/o price!
Perth solicitors property centre is another link to try.
If you aren't sure of area's, PM and I'll give you the lowdown!