If you're not looking to change careers, and just want it for farting around locally, you can look into the sport pilot stuff. The original rules were pretty restrictive, but some of those restrictions are changing soon due to MOSAIC (pilots later this year, aircraft next year).

If you want to travel a bit with it, private is a good place, but you definitely don't need to go to a "school" (they're geared towards career track).