The leader of Bournemouth council has written to promoters BH Live urging them to reconsider hosting a Marilyn Manson concert amid sexual abuse allegations.