Thanks, Ubuntu sounds like a fun project..
Ubuntu is more than a fun project, it is a viable OS and can do pretty much all that XP can/could and more. Apart from a software repository that has pretty much everything you'd need, there is a program/app called WINE, which allows Ubuntu and other Linux users to install Windows applications within it. Now please don't get me wrong here, I am not suggesting that you ditch Windows for Ubuntu.
I wouldn't, but it is an OS that, in a dual boot situation with XP, would serve most of your needs until you can get a dedicated Windows machine up and running. You could of course keep the Ubuntu and XP machine even when you do find a replacement capable of running Win 7 or 8/8.1.
As for Dell, HP, Acer, etc, there's not a lot of difference between evenly matched machines and one is as good as the other. You best bet would be to inspect the machines on offer and make a decision on how well it performs, etc. Now some of these machines will take hardware upgrades and others won't, so ask before you buy anything. Usually the lower end machines are not upradedable while mid to upper range PCs will generally accept more RAM, a dedicated graphics card and additional HDDs. Again, check and be sure before you buy anything... in some cases 2nd hand/used goods can be non-returnable.