Yes, an antique is an option but you had better do your research first. Antique firearms are very different from their modern counterparts and cannot be treated the same.
If you want something shootable then I hope you reload. Most antiques are in calibers that are no longer commercially available which means you have to make your own. They use soft lead bullets and not modern jacketed bullets so you will be casting your own bullets or buying them from someone who casts. Brass is often difficult or non-existent but in some examples can be crafted from other existing calibers.
Antiques tend to be delicate. The science of metallurgy wasn't nearly as advanced 120 years ago as it is today. Most antiques were designed for black powder loads and as a result they aren't nearly as powerful as modern firearms. This has to be kept in mind when reloading so as to not turn your antique into a hand grenade. It is possible to reload for antique cartridge guns with modern smokeless powder but care has to be taken here as well since the load needs to be weak enough to be safe and the pressure curve should match black powder as much as possible.
You may see antique firearms for sale that have been converted to a modern caliber. This does NOT mean you can shoot modern ammunition through them. To do so is to invite disaster. All it means is that brass will be readily available. You will still have to reload them with soft lead and reduced charges for much lower pressures. The trade-off for the easy to find brass is that you now have an antique that is not in the original caliber so the collector value is lost.
In my opinion, antique guns that have had their calibers modified for modern ammunition are to be avoided. If someone was desperate enough to modify the caliber who knows how well the work was done or what ammunition has been put through it. Many guns will fire some modern rounds before failing. Once the damage is done however it will continue to weaken with even proper black powder loads and there may be no obvious visible sign of damage until it finally fails.
If you do the proper research and take the proper precautions then antique firearms can be a very rewarding hobby.
If you merely want to be able to shoot a handgun then I would suggest you get your RPAL and find a suitable modern handgun as that will be much safer for yourself and others.