Synchrotron-Based Studies of Transition Metal Incorporation into Silica-Based Sol-Gel Materials