To find out if a source has any spells, you can go to D&D Beyond's spell search and filter by sources.
This will work even if you don't have the books purchased on D&D Beyond. The sources at the time of my most recent edit that have spells are:
- Basic Rules
- Elemental Evil Player's Companion
- Player's Handbook
- Xanathar's Guide to Everything
- Sword Coast Adventurer's Guide
- Acquisitions Incorporated
- Explorer's Guide to Wildemount
- Guildmaster's Guide to Ravnica
- Lost Laboratory of Kwalish
(for some reason the Dungeon Master's Guide and Monster Manual are listed as having all of the spells in the Player's Handbook, but I can confirm that they are not in there.)
(this book reprints wall of water as it appears as a racial spell for Tritons, but for some reason D&D Beyond does not show that fact )