Suspect opened fire at several locations, including a major tourist hub, before he was shot and wounded by police