The Magic Fountain is situated on Montjuïc Hill in Barcelona, right in front of the National Art Museum of Catalonia (MNAC). It is easily accessible by public transportation, making it a popular attraction for both locals and tourists.