Louis Meehan was pronounced dead at the scene of the shooting in a community centre car park on Wednesday afternoon, police said, as cops are searching for witnesses