Detection of magnetic fields in the circumgalactic medium of nearby galaxies using Faraday rotation