Man charged with murder following motel shooting