The Magic Fountain of Montjuïc is located near Plaça Espanya and is easily accessible by metro; take the L1 or L3 line to Plaça Espanya station. Fountain show times vary depending on the season, typically starting around sunset and occurring at 30-minute intervals. It's recommended to check the official Barcelona tourism website for current schedules.