For differential (especially, for Sturm--Liouville) operators I would recommend Akhiezer, Glazman's "Theory of linear operators in Hilbert space" and Naimark's "Linear differential operators".
In von Neumann's classical book "Mathematical foundations of quantum mechanics" the spectral theorem is stated very roughly.