To activate the Mario feature in Google Maps, users can click on '?' icon next to the 'Start' navigation button for a prompt to enable 'Mario Time'. On activation, the feature will show Mario driving a kart as the pointer while the user is navigating. The feature is available only for a week to mark Mario Day on March 10.