I work next door to Debenair, and I have done some flying there. My impression is that it is a good place to train, with some good and motivated instructors. It does, however, fly a fleet of rather old and some might say beat-up planes. They do their best to keep 'em flying, but the planes are not exactly the best looking bunch around. The airport itself is VERY good for training. It is towered, has instrument approaches, is fairly busy (makes for good training) and it is under constant improvement. They just finished repaving some of the taxiways, and the main runway was repaved a few years ago. A new terminal building is also planned.
Titusville itself is nothing to long for. It is a smallish place with almost no social life apart from a couple of bars. It is pretty close to Orlando, Cocoa and Daytona, so the possibilities are many.
Hope this helps. Fly safe