[bug] In the CMakeDeps Generator CONAN_FOUND_LIBRARY and CONAN_SHARED_FOUND_LIBRARY are not cleared
### Environment details

* Operating System+version: Windows 10 & Linux
* Compiler+version: MSVC 19 & gcc 11.3.0
* Conan version: 2.0.2
* Python version: 3.10.6




### Steps to reproduce

1. Create a conan project with a dependecy and CMakeDeps generator
2. execute conan install
3. Have a look at the created cmakedeps_macros.cmake

in the function `conan_package_library_targets` line 23 the variable `CONAN_FOUND_LIBRARY` is filled with the found library. This call will write the variable into the cache. The same goes for the variable `CONAN_SHARED_FOUND_LIBRARY` in line 35. While this works for the first library in this foreach loop, each following call will not search for the library and update the variable, but takes them from the cache. So this way all the libraries end up with the same .lib and .dll files. So either the variable needs to be cleared after each foreach loop, or the NO_CACHE option needs to be used in the find_library execution. Another possible solution would be to create a new variable for every library (e.g. CONAN_FOUND_LIBRARY_${LIB_NAME} and CONAN_SHARED_FOUND_LIBRARY_${LIB_NAME})

### Logs

_No response_
diff --git a/conan/tools/cmake/cmakedeps/templates/macros.py b/conan/tools/cmake/cmakedeps/templates/macros.py
index 9d0824a04..d3249bcea 100644
--- a/conan/tools/cmake/cmakedeps/templates/macros.py
+++ b/conan/tools/cmake/cmakedeps/templates/macros.py
@@ -76,6 +76,7 @@ class MacrosTemplate(CMakeDepsFileTemplate):
                         set_target_properties(${_LIB_NAME} PROPERTIES IMPORTED_IMPLIB ${CONAN_FOUND_LIBRARY})
                         message(DEBUG "Found DLL and STATIC at ${CONAN_SHARED_FOUND_LIBRARY}, ${CONAN_FOUND_LIBRARY}")
                      endif()
+                     unset(CONAN_SHARED_FOUND_LIBRARY CACHE)
                    else()
                      if(NOT TARGET ${_LIB_NAME})
                          # library_type can be STATIC, still UNKNOWN (if no package type available in the recipe) or SHARED (but no windows)
['conan/tools/cmake/cmakedeps/templates/macros.py']