[I'm hoping to take an introductory flight at one of the smaller flight schools around to see what it's like.]
Very good idea. If you enjoy it, a little warning...
The path ahead is hard, frustrating, can be long and costly.
However, if you are a positive person, and like flying for flying, ITS VERY ENJOYABLE AND REWARDING (and highly addictive).