If your husband works near Union Station in DC you could live North of Leesburg or near Lovettsville and get the MARC train in Point of Rocks. Eastern Loudoun has more developments and newer homes. Western Loudoun has some smalll towns like Waterford, Hillsboro, Lincoln and Aldie that still have small elementary schools. Eastern Leesburg is like Eastern Loudoun. But the western side of Leesburg and the town of Purcellville have charming older downtown areas and neighborhoods.
For schools both the county school district have their strength depending on what you are looking for a school to provide.